About

Amgothu Ravi Kumar is a professional and highly motivated Senior Systems Operations Engineer with around 2.9 years of experience in MySQL DBA and development activities. He is currently working at Wells Fargo International Solutions Pvt. Ltd. and has previously worked at EPAM Systems and Agilite Group. Ravi Kumar has rich experience in data migration/integration activities using SQL Scripts and Talend Open Studio. He has expertise in installation/configuration and up-gradation of MySQL on Windows/Linux platforms. He ensures high availability of databases by setting and maintaining MySQL Master-Slave and Master-Master Replication. Ravi Kumar optimizes MySQL server performance by re-writing optimized queries, creating required indexes, using appropriate data types for columns, and tuning MySQL parameters. He has excellent knowledge of different storage engines of MySQL, especially InnoDB, MyISAM, and Memory. Ravi Kumar performs day-to-day DBA activities like backup, monitoring, query optimization, performance tuning, and maintains database security by creating and maintaining users and roles, assign privileges. He works closely with the application development team and assists them with daily operations. Ravi Kumar has experience in creating development, staging, and production database instances and synchronizing those instances from one environment to another. He writes Stored Procedures/Functions/Triggers in PL/SQL and has rich experience in managing large size production databases. He uses tools like SQLYog, Percona-Toolkit, Percona Xtrabackup, MySQL Workbench, MySQL Administrator, and Putty to perform DBA tasks efficiently. Ravi Kumar is an expert in data migration using SQL Scripts (Stored Procedures using Cursors) and data integration and migration using Talend Open Studio. He has expertise in using Talend Administrator Center. With a fresh mind and approach, he is open to learning and delivering in diverse areas and has the ability to focus towards enhanced output at each juncture. Ravi Kumar holds a Master of Computer Applications (MCA) degree in Computer Science from National Institute of Technology Raipur and a Bachelor's degree in Mathematics, Physics, and Computer Science from Kakatiya University, Gandhi Degree College. He has relevant experience of 8.61 years and possesses skills in MySQL, SQL, Integration, Software Engineering, and Big Data.